package com.sujiewon.salesadmin.customer.dao;

import java.sql.SQLException;
import java.util.HashMap;
import java.util.List;

public interface CustomerDao {
	
	public void updateSeqId() throws SQLException;

	public int getSeqId() throws SQLException;

	public HashMap<String, Object> getCustInfoByCustId(HashMap<String, Object> param) throws SQLException;

	public void nextSeqId() throws SQLException;

	public void registerBasicInfo(HashMap<String, Object> paramMap) throws SQLException;

	public List<HashMap<String, Object>> getCustInfoList(HashMap<String, Object> paramMap) throws SQLException;
	
	public List<HashMap<String, Object>> getCustCtrtInfoList(HashMap<String, Object> paramMap) throws SQLException;

	public void registerCustMgrInfo(HashMap<String, Object> paramMap) throws SQLException;

	public void registerProjectContractInfo(HashMap<String, Object> paramMap) throws SQLException;

	public HashMap<String, Object> getCustMgrInfo(HashMap<String, Object> paramMap) throws SQLException;

	public void registerSalesProcess(HashMap<String, Object> paramMap) throws SQLException;

	public List<HashMap<String, Object>> searchSalesProcess(HashMap<String, Object> paramMap) throws SQLException;

	public HashMap<String, Object> getProjectContractInfo(HashMap<String, Object> paramMap) throws SQLException;

	public List<HashMap<String, Object>> getSalesInfoList(HashMap<String, Object> paramMap) throws SQLException;

	public void updateCustMgrInfo(HashMap<String, Object> paramMap) throws SQLException;

	public void updateProjectContractInfo(HashMap<String, Object> paramMap) throws SQLException;

	public void updateSalesInfo(HashMap<String, Object> paramMap) throws SQLException;

	public void updateBasicInfo(HashMap<String, Object> paramMap) throws SQLException;

	public int totalCountSalesProcess(HashMap<String, Object> paramMap) throws SQLException;

	public List<HashMap<String, Object>> getCustAllInfoList(HashMap<String, Object> paramMap) throws SQLException;

	public int totalCustAllCount(HashMap<String, Object> paramMap) throws SQLException;
	
	public void deleteSalesMgr(HashMap<String, Object> paramMap) throws SQLException;

	public void deleteCustCtrtPrj(HashMap<String, Object> paramMap) throws SQLException;

	public void deleteCustMgr(HashMap<String, Object> paramMap) throws SQLException;

	public void deleteCustInfo(HashMap<String, Object> paramMap) throws SQLException;

	public void deleteMatnSvc(HashMap<String, Object> paramMap) throws SQLException;

	public void deleteMatnMgr(HashMap<String, Object> paramMap) throws SQLException;

	public void deleteCustCtrtMatn(HashMap<String, Object> paramMap) throws SQLException;

	public List<HashMap<String, Object>> getProjectReportList(HashMap<String, Object> paramMap) throws SQLException;

	public int totalCountProjectReport(HashMap<String, Object> paramMap) throws SQLException;

	public List<HashMap<String, Object>> getProjectList(HashMap<String, Object> paramMap) throws SQLException;

	public int totalCountProjectList(HashMap<String, Object> paramMap) throws SQLException;

	public String getLastCustId() throws SQLException;

}
